<#assign prefixName = 'WHERE'>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_beginDate??)>
	<#if (where_and_eq_beginDate_value??)>
${prefixName} T.BEGIN_DATE = :where_and_eq_beginDate_value
	<#else>
${prefixName} T.BEGIN_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_beginDate_value??)>
${prefixName} T.BEGIN_DATE <> :where_and_nq_beginDate_value
	<#else>
${prefixName} T.BEGIN_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_beginDate_value??)>
${prefixName} T.BEGIN_DATE <> :where_and_like_beginDate_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_beginDate_value??)>
${prefixName} T.BEGIN_DATE = :where_or_eq_beginDate_value
	<#else>
${prefixName} T.BEGIN_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_beginDate_value??)>
${prefixName} T.BEGIN_DATE <> :where_or_nq_beginDate_value
	<#else>
${prefixName} T.BEGIN_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_beginDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_beginDate_value??)>
${prefixName} T.BEGIN_DATE like :where_or_like_beginDate_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_createdByCode??)>
	<#if (where_and_eq_createdByCode_value??)>
${prefixName} T.CREATED_BY_CODE = :where_and_eq_createdByCode_value
	<#else>
${prefixName} T.CREATED_BY_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_createdByCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_createdByCode_value??)>
${prefixName} T.CREATED_BY_CODE <> :where_and_nq_createdByCode_value
	<#else>
${prefixName} T.CREATED_BY_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_createdByCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_createdByCode_value??)>
${prefixName} T.CREATED_BY_CODE <> :where_and_like_createdByCode_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_createdByCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_createdByCode_value??)>
${prefixName} T.CREATED_BY_CODE = :where_or_eq_createdByCode_value
	<#else>
${prefixName} T.CREATED_BY_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_createdByCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_createdByCode_value??)>
${prefixName} T.CREATED_BY_CODE <> :where_or_nq_createdByCode_value
	<#else>
${prefixName} T.CREATED_BY_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_createdByCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_createdByCode_value??)>
${prefixName} T.CREATED_BY_CODE like :where_or_like_createdByCode_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_createdById??)>
	<#if (where_and_eq_createdById_value??)>
${prefixName} T.CREATED_BY_ID = :where_and_eq_createdById_value
	<#else>
${prefixName} T.CREATED_BY_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_createdById??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_createdById_value??)>
${prefixName} T.CREATED_BY_ID <> :where_and_nq_createdById_value
	<#else>
${prefixName} T.CREATED_BY_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_createdById??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_createdById_value??)>
${prefixName} T.CREATED_BY_ID <> :where_and_like_createdById_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_createdById??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_createdById_value??)>
${prefixName} T.CREATED_BY_ID = :where_or_eq_createdById_value
	<#else>
${prefixName} T.CREATED_BY_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_createdById??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_createdById_value??)>
${prefixName} T.CREATED_BY_ID <> :where_or_nq_createdById_value
	<#else>
${prefixName} T.CREATED_BY_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_createdById??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_createdById_value??)>
${prefixName} T.CREATED_BY_ID like :where_or_like_createdById_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_createdByName??)>
	<#if (where_and_eq_createdByName_value??)>
${prefixName} T.CREATED_BY_NAME = :where_and_eq_createdByName_value
	<#else>
${prefixName} T.CREATED_BY_NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_createdByName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_createdByName_value??)>
${prefixName} T.CREATED_BY_NAME <> :where_and_nq_createdByName_value
	<#else>
${prefixName} T.CREATED_BY_NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_createdByName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_createdByName_value??)>
${prefixName} T.CREATED_BY_NAME <> :where_and_like_createdByName_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_createdByName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_createdByName_value??)>
${prefixName} T.CREATED_BY_NAME = :where_or_eq_createdByName_value
	<#else>
${prefixName} T.CREATED_BY_NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_createdByName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_createdByName_value??)>
${prefixName} T.CREATED_BY_NAME <> :where_or_nq_createdByName_value
	<#else>
${prefixName} T.CREATED_BY_NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_createdByName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_createdByName_value??)>
${prefixName} T.CREATED_BY_NAME like :where_or_like_createdByName_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_createdDate??)>
	<#if (where_and_eq_createdDate_value??)>
${prefixName} T.CREATED_DATE = :where_and_eq_createdDate_value
	<#else>
${prefixName} T.CREATED_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_createdDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_createdDate_value??)>
${prefixName} T.CREATED_DATE <> :where_and_nq_createdDate_value
	<#else>
${prefixName} T.CREATED_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_createdDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_createdDate_value??)>
${prefixName} T.CREATED_DATE <> :where_and_like_createdDate_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_createdDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_createdDate_value??)>
${prefixName} T.CREATED_DATE = :where_or_eq_createdDate_value
	<#else>
${prefixName} T.CREATED_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_createdDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_createdDate_value??)>
${prefixName} T.CREATED_DATE <> :where_or_nq_createdDate_value
	<#else>
${prefixName} T.CREATED_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_createdDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_createdDate_value??)>
${prefixName} T.CREATED_DATE like :where_or_like_createdDate_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_endDate??)>
	<#if (where_and_eq_endDate_value??)>
${prefixName} T.END_DATE = :where_and_eq_endDate_value
	<#else>
${prefixName} T.END_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_endDate_value??)>
${prefixName} T.END_DATE <> :where_and_nq_endDate_value
	<#else>
${prefixName} T.END_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_endDate_value??)>
${prefixName} T.END_DATE <> :where_and_like_endDate_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_endDate_value??)>
${prefixName} T.END_DATE = :where_or_eq_endDate_value
	<#else>
${prefixName} T.END_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_endDate_value??)>
${prefixName} T.END_DATE <> :where_or_nq_endDate_value
	<#else>
${prefixName} T.END_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_endDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_endDate_value??)>
${prefixName} T.END_DATE like :where_or_like_endDate_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_between_sysdate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'AND'>
</#if>
${prefixName} NOW() BETWEEN IFNULL(T.BEGIN_DATE, NOW()) AND IFNULL(T.END_DATE, NOW())
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_entityCode??)>
	<#if (where_and_eq_entityCode_value??)>
${prefixName} T.ENTITY_CODE = :where_and_eq_entityCode_value
	<#else>
${prefixName} T.ENTITY_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_entityCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_entityCode_value??)>
${prefixName} T.ENTITY_CODE <> :where_and_nq_entityCode_value
	<#else>
${prefixName} T.ENTITY_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_entityCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_entityCode_value??)>
${prefixName} T.ENTITY_CODE <> :where_and_like_entityCode_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_entityCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_entityCode_value??)>
${prefixName} T.ENTITY_CODE = :where_or_eq_entityCode_value
	<#else>
${prefixName} T.ENTITY_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_entityCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_entityCode_value??)>
${prefixName} T.ENTITY_CODE <> :where_or_nq_entityCode_value
	<#else>
${prefixName} T.ENTITY_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_entityCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_entityCode_value??)>
${prefixName} T.ENTITY_CODE like :where_or_like_entityCode_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_entityId??)>
	<#if (where_and_eq_entityId_value??)>
${prefixName} T.ENTITY_ID = :where_and_eq_entityId_value
	<#else>
${prefixName} T.ENTITY_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_entityId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_entityId_value??)>
${prefixName} T.ENTITY_ID <> :where_and_nq_entityId_value
	<#else>
${prefixName} T.ENTITY_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_entityId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_entityId_value??)>
${prefixName} T.ENTITY_ID <> :where_and_like_entityId_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_entityId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_entityId_value??)>
${prefixName} T.ENTITY_ID = :where_or_eq_entityId_value
	<#else>
${prefixName} T.ENTITY_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_entityId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_entityId_value??)>
${prefixName} T.ENTITY_ID <> :where_or_nq_entityId_value
	<#else>
${prefixName} T.ENTITY_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_entityId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_entityId_value??)>
${prefixName} T.ENTITY_ID like :where_or_like_entityId_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_entityName??)>
	<#if (where_and_eq_entityName_value??)>
${prefixName} T.ENTITY_NAME = :where_and_eq_entityName_value
	<#else>
${prefixName} T.ENTITY_NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_entityName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_entityName_value??)>
${prefixName} T.ENTITY_NAME <> :where_and_nq_entityName_value
	<#else>
${prefixName} T.ENTITY_NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_entityName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_entityName_value??)>
${prefixName} T.ENTITY_NAME <> :where_and_like_entityName_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_entityName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_entityName_value??)>
${prefixName} T.ENTITY_NAME = :where_or_eq_entityName_value
	<#else>
${prefixName} T.ENTITY_NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_entityName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_entityName_value??)>
${prefixName} T.ENTITY_NAME <> :where_or_nq_entityName_value
	<#else>
${prefixName} T.ENTITY_NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_entityName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_entityName_value??)>
${prefixName} T.ENTITY_NAME like :where_or_like_entityName_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_entityParentCode??)>
	<#if (where_and_eq_entityParentCode_value??)>
${prefixName} T.ENTITY_PARENT_CODE = :where_and_eq_entityParentCode_value
	<#else>
${prefixName} T.ENTITY_PARENT_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_entityParentCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_entityParentCode_value??)>
${prefixName} T.ENTITY_PARENT_CODE <> :where_and_nq_entityParentCode_value
	<#else>
${prefixName} T.ENTITY_PARENT_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_entityParentCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_entityParentCode_value??)>
${prefixName} T.ENTITY_PARENT_CODE <> :where_and_like_entityParentCode_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_entityParentCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_entityParentCode_value??)>
${prefixName} T.ENTITY_PARENT_CODE = :where_or_eq_entityParentCode_value
	<#else>
${prefixName} T.ENTITY_PARENT_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_entityParentCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_entityParentCode_value??)>
${prefixName} T.ENTITY_PARENT_CODE <> :where_or_nq_entityParentCode_value
	<#else>
${prefixName} T.ENTITY_PARENT_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_entityParentCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_entityParentCode_value??)>
${prefixName} T.ENTITY_PARENT_CODE like :where_or_like_entityParentCode_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_entityParentId??)>
	<#if (where_and_eq_entityParentId_value??)>
${prefixName} T.ENTITY_PARENT_ID = :where_and_eq_entityParentId_value
	<#else>
${prefixName} T.ENTITY_PARENT_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_entityParentId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_entityParentId_value??)>
${prefixName} T.ENTITY_PARENT_ID <> :where_and_nq_entityParentId_value
	<#else>
${prefixName} T.ENTITY_PARENT_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_entityParentId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_entityParentId_value??)>
${prefixName} T.ENTITY_PARENT_ID <> :where_and_like_entityParentId_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_entityParentId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_entityParentId_value??)>
${prefixName} T.ENTITY_PARENT_ID = :where_or_eq_entityParentId_value
	<#else>
${prefixName} T.ENTITY_PARENT_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_entityParentId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_entityParentId_value??)>
${prefixName} T.ENTITY_PARENT_ID <> :where_or_nq_entityParentId_value
	<#else>
${prefixName} T.ENTITY_PARENT_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_entityParentId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_entityParentId_value??)>
${prefixName} T.ENTITY_PARENT_ID like :where_or_like_entityParentId_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_entityParentName??)>
	<#if (where_and_eq_entityParentName_value??)>
${prefixName} T.ENTITY_PARENT_NAME = :where_and_eq_entityParentName_value
	<#else>
${prefixName} T.ENTITY_PARENT_NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_entityParentName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_entityParentName_value??)>
${prefixName} T.ENTITY_PARENT_NAME <> :where_and_nq_entityParentName_value
	<#else>
${prefixName} T.ENTITY_PARENT_NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_entityParentName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_entityParentName_value??)>
${prefixName} T.ENTITY_PARENT_NAME <> :where_and_like_entityParentName_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_entityParentName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_entityParentName_value??)>
${prefixName} T.ENTITY_PARENT_NAME = :where_or_eq_entityParentName_value
	<#else>
${prefixName} T.ENTITY_PARENT_NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_entityParentName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_entityParentName_value??)>
${prefixName} T.ENTITY_PARENT_NAME <> :where_or_nq_entityParentName_value
	<#else>
${prefixName} T.ENTITY_PARENT_NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_entityParentName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_entityParentName_value??)>
${prefixName} T.ENTITY_PARENT_NAME like :where_or_like_entityParentName_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_id??)>
	<#if (where_and_eq_id_value??)>
${prefixName} T.ID = :where_and_eq_id_value
	<#else>
${prefixName} T.ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_id_value??)>
${prefixName} T.ID <> :where_and_nq_id_value
	<#else>
${prefixName} T.ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_id_value??)>
${prefixName} T.ID <> :where_and_like_id_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_id_value??)>
${prefixName} T.ID = :where_or_eq_id_value
	<#else>
${prefixName} T.ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_id_value??)>
${prefixName} T.ID <> :where_or_nq_id_value
	<#else>
${prefixName} T.ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_id??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_id_value??)>
${prefixName} T.ID like :where_or_like_id_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_lastModifiedByCode??)>
	<#if (where_and_eq_lastModifiedByCode_value??)>
${prefixName} T.LAST_MODIFIED_BY_CODE = :where_and_eq_lastModifiedByCode_value
	<#else>
${prefixName} T.LAST_MODIFIED_BY_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_lastModifiedByCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_lastModifiedByCode_value??)>
${prefixName} T.LAST_MODIFIED_BY_CODE <> :where_and_nq_lastModifiedByCode_value
	<#else>
${prefixName} T.LAST_MODIFIED_BY_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_lastModifiedByCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_lastModifiedByCode_value??)>
${prefixName} T.LAST_MODIFIED_BY_CODE <> :where_and_like_lastModifiedByCode_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_lastModifiedByCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_lastModifiedByCode_value??)>
${prefixName} T.LAST_MODIFIED_BY_CODE = :where_or_eq_lastModifiedByCode_value
	<#else>
${prefixName} T.LAST_MODIFIED_BY_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_lastModifiedByCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_lastModifiedByCode_value??)>
${prefixName} T.LAST_MODIFIED_BY_CODE <> :where_or_nq_lastModifiedByCode_value
	<#else>
${prefixName} T.LAST_MODIFIED_BY_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_lastModifiedByCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_lastModifiedByCode_value??)>
${prefixName} T.LAST_MODIFIED_BY_CODE like :where_or_like_lastModifiedByCode_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_lastModifiedById??)>
	<#if (where_and_eq_lastModifiedById_value??)>
${prefixName} T.LAST_MODIFIED_BY_ID = :where_and_eq_lastModifiedById_value
	<#else>
${prefixName} T.LAST_MODIFIED_BY_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_lastModifiedById??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_lastModifiedById_value??)>
${prefixName} T.LAST_MODIFIED_BY_ID <> :where_and_nq_lastModifiedById_value
	<#else>
${prefixName} T.LAST_MODIFIED_BY_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_lastModifiedById??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_lastModifiedById_value??)>
${prefixName} T.LAST_MODIFIED_BY_ID <> :where_and_like_lastModifiedById_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_lastModifiedById??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_lastModifiedById_value??)>
${prefixName} T.LAST_MODIFIED_BY_ID = :where_or_eq_lastModifiedById_value
	<#else>
${prefixName} T.LAST_MODIFIED_BY_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_lastModifiedById??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_lastModifiedById_value??)>
${prefixName} T.LAST_MODIFIED_BY_ID <> :where_or_nq_lastModifiedById_value
	<#else>
${prefixName} T.LAST_MODIFIED_BY_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_lastModifiedById??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_lastModifiedById_value??)>
${prefixName} T.LAST_MODIFIED_BY_ID like :where_or_like_lastModifiedById_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_lastModifiedByName??)>
	<#if (where_and_eq_lastModifiedByName_value??)>
${prefixName} T.LAST_MODIFIED_BY_NAME = :where_and_eq_lastModifiedByName_value
	<#else>
${prefixName} T.LAST_MODIFIED_BY_NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_lastModifiedByName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_lastModifiedByName_value??)>
${prefixName} T.LAST_MODIFIED_BY_NAME <> :where_and_nq_lastModifiedByName_value
	<#else>
${prefixName} T.LAST_MODIFIED_BY_NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_lastModifiedByName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_lastModifiedByName_value??)>
${prefixName} T.LAST_MODIFIED_BY_NAME <> :where_and_like_lastModifiedByName_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_lastModifiedByName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_lastModifiedByName_value??)>
${prefixName} T.LAST_MODIFIED_BY_NAME = :where_or_eq_lastModifiedByName_value
	<#else>
${prefixName} T.LAST_MODIFIED_BY_NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_lastModifiedByName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_lastModifiedByName_value??)>
${prefixName} T.LAST_MODIFIED_BY_NAME <> :where_or_nq_lastModifiedByName_value
	<#else>
${prefixName} T.LAST_MODIFIED_BY_NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_lastModifiedByName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_lastModifiedByName_value??)>
${prefixName} T.LAST_MODIFIED_BY_NAME like :where_or_like_lastModifiedByName_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_lastModifiedDate??)>
	<#if (where_and_eq_lastModifiedDate_value??)>
${prefixName} T.LAST_MODIFIED_DATE = :where_and_eq_lastModifiedDate_value
	<#else>
${prefixName} T.LAST_MODIFIED_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_lastModifiedDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_lastModifiedDate_value??)>
${prefixName} T.LAST_MODIFIED_DATE <> :where_and_nq_lastModifiedDate_value
	<#else>
${prefixName} T.LAST_MODIFIED_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_lastModifiedDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_lastModifiedDate_value??)>
${prefixName} T.LAST_MODIFIED_DATE <> :where_and_like_lastModifiedDate_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_lastModifiedDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_lastModifiedDate_value??)>
${prefixName} T.LAST_MODIFIED_DATE = :where_or_eq_lastModifiedDate_value
	<#else>
${prefixName} T.LAST_MODIFIED_DATE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_lastModifiedDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_lastModifiedDate_value??)>
${prefixName} T.LAST_MODIFIED_DATE <> :where_or_nq_lastModifiedDate_value
	<#else>
${prefixName} T.LAST_MODIFIED_DATE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_lastModifiedDate??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_lastModifiedDate_value??)>
${prefixName} T.LAST_MODIFIED_DATE like :where_or_like_lastModifiedDate_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_stateId??)>
	<#if (where_and_eq_stateId_value??)>
${prefixName} T.STATE_ID = :where_and_eq_stateId_value
	<#else>
${prefixName} T.STATE_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_stateId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_stateId_value??)>
${prefixName} T.STATE_ID <> :where_and_nq_stateId_value
	<#else>
${prefixName} T.STATE_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_stateId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_stateId_value??)>
${prefixName} T.STATE_ID <> :where_and_like_stateId_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_stateId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_stateId_value??)>
${prefixName} T.STATE_ID = :where_or_eq_stateId_value
	<#else>
${prefixName} T.STATE_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_stateId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_stateId_value??)>
${prefixName} T.STATE_ID <> :where_or_nq_stateId_value
	<#else>
${prefixName} T.STATE_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_stateId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_stateId_value??)>
${prefixName} T.STATE_ID like :where_or_like_stateId_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_treeCode??)>
	<#if (where_and_eq_treeCode_value??)>
${prefixName} T.TREE_CODE = :where_and_eq_treeCode_value
	<#else>
${prefixName} T.TREE_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_treeCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_treeCode_value??)>
${prefixName} T.TREE_CODE <> :where_and_nq_treeCode_value
	<#else>
${prefixName} T.TREE_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_treeCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_treeCode_value??)>
${prefixName} T.TREE_CODE <> :where_and_like_treeCode_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_treeCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_treeCode_value??)>
${prefixName} T.TREE_CODE = :where_or_eq_treeCode_value
	<#else>
${prefixName} T.TREE_CODE IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_treeCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_treeCode_value??)>
${prefixName} T.TREE_CODE <> :where_or_nq_treeCode_value
	<#else>
${prefixName} T.TREE_CODE IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_treeCode??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_treeCode_value??)>
${prefixName} T.TREE_CODE like :where_or_like_treeCode_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_treeId??)>
	<#if (where_and_eq_treeId_value??)>
${prefixName} T.TREE_ID = :where_and_eq_treeId_value
	<#else>
${prefixName} T.TREE_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_treeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_treeId_value??)>
${prefixName} T.TREE_ID <> :where_and_nq_treeId_value
	<#else>
${prefixName} T.TREE_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_treeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_treeId_value??)>
${prefixName} T.TREE_ID <> :where_and_like_treeId_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_treeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_treeId_value??)>
${prefixName} T.TREE_ID = :where_or_eq_treeId_value
	<#else>
${prefixName} T.TREE_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_treeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_treeId_value??)>
${prefixName} T.TREE_ID <> :where_or_nq_treeId_value
	<#else>
${prefixName} T.TREE_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_treeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_treeId_value??)>
${prefixName} T.TREE_ID like :where_or_like_treeId_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_treeName??)>
	<#if (where_and_eq_treeName_value??)>
${prefixName} T.TREE_NAME = :where_and_eq_treeName_value
	<#else>
${prefixName} T.TREE_NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_treeName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_treeName_value??)>
${prefixName} T.TREE_NAME <> :where_and_nq_treeName_value
	<#else>
${prefixName} T.TREE_NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_treeName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_treeName_value??)>
${prefixName} T.TREE_NAME <> :where_and_like_treeName_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_treeName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_treeName_value??)>
${prefixName} T.TREE_NAME = :where_or_eq_treeName_value
	<#else>
${prefixName} T.TREE_NAME IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_treeName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_treeName_value??)>
${prefixName} T.TREE_NAME <> :where_or_nq_treeName_value
	<#else>
${prefixName} T.TREE_NAME IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_treeName??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_treeName_value??)>
${prefixName} T.TREE_NAME like :where_or_like_treeName_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_typeId??)>
	<#if (where_and_eq_typeId_value??)>
${prefixName} T.TYPE_ID = :where_and_eq_typeId_value
	<#else>
${prefixName} T.TYPE_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_typeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_typeId_value??)>
${prefixName} T.TYPE_ID <> :where_and_nq_typeId_value
	<#else>
${prefixName} T.TYPE_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_typeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_typeId_value??)>
${prefixName} T.TYPE_ID <> :where_and_like_typeId_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_typeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_typeId_value??)>
${prefixName} T.TYPE_ID = :where_or_eq_typeId_value
	<#else>
${prefixName} T.TYPE_ID IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_typeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_typeId_value??)>
${prefixName} T.TYPE_ID <> :where_or_nq_typeId_value
	<#else>
${prefixName} T.TYPE_ID IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_typeId??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_typeId_value??)>
${prefixName} T.TYPE_ID like :where_or_like_typeId_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
<#if (where_and_eq_version??)>
	<#if (where_and_eq_version_value??)>
${prefixName} T.VERSION = :where_and_eq_version_value
	<#else>
${prefixName} T.VERSION IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_nq_version??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_nq_version_value??)>
${prefixName} T.VERSION <> :where_and_nq_version_value
	<#else>
${prefixName} T.VERSION IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_and_like_version??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName='AND'>
</#if>
	<#if (where_and_like_version_value??)>
${prefixName} T.VERSION <> :where_and_like_version_value
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_eq_version??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_eq_version_value??)>
${prefixName} T.VERSION = :where_or_eq_version_value
	<#else>
${prefixName} T.VERSION IS NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_nq_version??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_nq_version_value??)>
${prefixName} T.VERSION <> :where_or_nq_version_value
	<#else>
${prefixName} T.VERSION IS NOT NULL
	</#if>
	<#assign prefixName = ''>
</#if>
<#if (where_or_like_version??)>
<#if (prefixName!) != 'WHERE'>
	<#assign prefixName = 'OR'>
</#if>
	<#if (where_or_like_version_value??)>
${prefixName} T.VERSION like :where_or_like_version_value
	</#if>
	<#assign prefixName = ''>
</#if>
